#ERROR? in control when running form...due to can't evaluate expression.
Cause:
The syntax in the expression is incorrect.
Solution:
Ensure that the expression syntax is correct. In the Form Design view or Report design view, select the desired control, select the 'View' menu, and select 'Properties'. Select the 'Data' tab, and check syntax of the Control Source expression.
1) If the Database window is not active, activate the Database window.
2) Click the 'Forms' tab or the 'Reports' tab in the Database window.
Forms tab
3) Select the desired form or report from the list box. (The selected former report is highlighted.)
4) Click 'Design'. (The selected form or report and the floating Toolbox appear.)
5) Click to select the desired control. (Handles appear around the control.)
Handles appear around control
6) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
7) Click the 'Data' tab.
Property sheet
8) Click in the 'Control Source' property box.
9) Ensure that the expression does not include the name of the selected control.
10) Edit the expression to ensure that the syntax has the proper number of spaces, delimiters, operators, etc.
11) To close the property sheet, click the 'X' in the upper-right hand corner of the property sheet.
Click X button to close property sheet
NOTE: The properties will be saved only when the design view is saved.
